<?php

use Illuminate\Database\Schema\Blueprint;

class CreateCaSmsTemplates extends \App\Utils\CreateMigration
{
    function columns(Blueprint $table)
    {
        $table->unsignedBigInteger('hospital_id')->default(0)->comment('医院编号');
        $table->string('name')->nullable()->comment('模板名称');
        $table->string('code')->nullable()->comment('编码');
        $table->string('content')->nullable()->comment('模板内容');
        $table->text('params')->nullable()->comment('参数');
        $table->index(['code', 'hospital_id'], 'idx_code_weight');
    }

    function tableInfo()
    {
        return ['ca__sms_templates', '咨询预约-短信模板'];
    }
}
